import tkinter as tk
import tkinter.ttk as ttk
import openpyxl
from time import process_time

from tools_pmc import lj_mccr


wb = openpyxl.load_workbook(lj_mccr)
ws = wb.worksheets[0]
list1 = [[], [], [], []]
for i in range(2, ws.max_row + 1):
    for j in range(0, 4):
        list1[j].append(ws.cell(i, j + 1).value)

# process_time()
# print(process_time())


root = tk.Tk()
root.title('物料状态变更工具')
root.geometry('450x300')

combobox1 = ttk.Combobox(root, values=list1[0])
combobox1.pack(padx=5, pady=5, side="top", anchor="nw")
label1 = tk.Label(root, text="起始日期选择:")
label1.pack(padx=5, pady=5, side="top", anchor="nw")

root.mainloop()
